<?php
/**
 *
 * @license http://www.gnu.org/licenses/gpl-3.0.txt
 * @encoding UTF-8
 *
 * Copyright (c) 2011 Charly Poly <charly.poly[at]live[dot]fr>
 * Copyright (c) 2011 <Prenom Nom> <email>
 * All rights reserved.
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 */
/**
 * Simple CRUD classe
 */
class Database {

    public static function select($table, $fields="*", $clause=null, $limit=NULL, $orderby=NULL) {
        /**
         * /!\ $clause doit être protégé !
         */
         
        $where = (($clause) ? "WHERE ".$clause : "" );

//        echo "<b>SELECT ".$fields." FROM ".$table." ".$where." ".(($limit) ? " LIMIT ".$limit : "")."</b><br>;";

        return Storage::getInstance()->fetch()->query("SELECT ".$fields." FROM ".$table." ".$where." ".(($orderby) ? " ORDER BY  ".$orderby. " DESC " : "  ").(($limit) ? " LIMIT ".$limit : "").";")->fetchAll(PDO::FETCH_ASSOC);
    }


    public static function insert($table, $datas, $lastInsertField=false) {
        /**
         * /!\ $clause doit être protégé !
         * @todo recursivité des insertions
         */
        $input = "(";
        array_walk_recursive($datas, "Database::quoteInsertElement");
        $input .= implode(", ", $datas);
        $input .= " )";
        $exec = Storage::getInstance()->fetch()->exec("INSERT INTO ".$table." VALUES " .$input." ;");
        if ($lastInsertField && $exec) return self::lastID($lastInsertField);
        else return $exec;
    }

    private static function quoteInsertElement(&$item, $key) {
        $item = (empty($item) ? 'DEFAULT' : self::q($item));
    }


    public static function lastID($field) {
        return S()->fetch()->lastInsertId($field);
    }

    public static function q($s) {
        return Storage::getInstance()->fetch()->quote($s);
    }
}
?>
